Pandas Profiling Report

Dataset statistics

Number of variables	8
Number of observations	1304
Missing cells	309
Missing cells (%)	3.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	81.6 KiB
Average record size in memory	64.1 B

Variable types

NUM	7
CAT	1

Warnings

`other_rooms` has 309 (23.7%) missing values	Missing
`df_index` has unique values	Unique
`bathrooms` has 15 (1.2%) zeros	Zeros
`other_rooms` has 977 (74.9%) zeros	Zeros

Reproduction

Analysis started	2021-06-05 21:03:49.897079
Analysis finished	2021-06-05 21:03:59.866774
Duration	9.97 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	1304
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	15850.53758
Minimum	286
Maximum	21727
Zeros	0
Zeros (%)	0.0%
Memory size	10.2 KiB

Quantile statistics

Minimum	286
5-th percentile	9117.8
Q1	13410.5
median	16353.5
Q3	18949.25
95-th percentile	20292.35
Maximum	21727
Range	21441
Interquartile range (IQR)	5538.75

Descriptive statistics

Standard deviation	3827.061894
Coefficient of variation (CV)	0.24144682
Kurtosis	2.443174668
Mean	15850.53758
Median Absolute Deviation (MAD)	2782
Skewness	-1.244995471
Sum	20669101
Variance	14646402.74
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12285	1	0.1%
17133	1	0.1%
19147	1	0.1%
21199	1	0.1%
21200	1	0.1%
13010	1	0.1%
13013	1	0.1%
19160	1	0.1%
21209	1	0.1%
21211	1	0.1%
Other values (1294)	1294	99.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
286	1	0.1%
287	1	0.1%
299	1	0.1%
419	1	0.1%
577	1	0.1%

Value	Count	Frequency (%)
21727	1	0.1%
21617	1	0.1%
21608	1	0.1%
21565	1	0.1%
21506	1	0.1%

property_status
Categorical

Distinct	4
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	10.2 KiB

Used	686
New	467
Not Applicable	150
Under Construction	1

Frequencies
Length

Value	Count	Frequency (%)
Used	686	52.6%
New	467	35.8%
Not Applicable	150	11.5%
Under Construction	1	0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	18
Median length	4
Mean length	4.80291411
Min length	3

price
Real number (ℝ_≥0)

Distinct	356
Distinct (%)	27.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	66895.77147
Minimum	280
Maximum	340000
Zeros	0
Zeros (%)	0.0%
Memory size	10.2 KiB

Quantile statistics

Minimum	280
5-th percentile	39075
Q1	52750
median	65000
Q3	77000
95-th percentile	101683.2
Maximum	340000
Range	339720
Interquartile range (IQR)	24250

Descriptive statistics

Standard deviation	23381.71764
Coefficient of variation (CV)	0.3495245982
Kurtosis	26.66177476
Mean	66895.77147
Median Absolute Deviation (MAD)	12000
Skewness	3.273071013
Sum	87232086
Variance	546704719.9
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
65000	48	3.7%
70000	42	3.2%
75000	42	3.2%
55000	30	2.3%
60000	28	2.1%
80000	27	2.1%
58000	26	2.0%
43000	26	2.0%
45000	26	2.0%
62000	25	1.9%
Other values (346)	984	75.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
280	1	0.1%
26000	1	0.1%
26500	1	0.1%
27000	1	0.1%
28000	1	0.1%

Value	Count	Frequency (%)
340000	1	0.1%
300000	1	0.1%
250000	1	0.1%
210000	1	0.1%
199000	1	0.1%

interior_area
Real number (ℝ_≥0)

Distinct	135
Distinct (%)	10.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	98.48389571
Minimum	40
Maximum	427
Zeros	0
Zeros (%)	0.0%
Memory size	10.2 KiB

Quantile statistics

Minimum	40
5-th percentile	63
Q1	76
median	99
Q3	112
95-th percentile	137
Maximum	427
Range	387
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	31.57548499
Coefficient of variation (CV)	0.3206157186
Kurtosis	24.61358459
Mean	98.48389571
Median Absolute Deviation (MAD)	16
Skewness	3.367160887
Sum	128423
Variance	997.0112523
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	43	3.3%
112	36	2.8%
108	32	2.5%
104	31	2.4%
98	30	2.3%
105	28	2.1%
106	28	2.1%
90	28	2.1%
70	27	2.1%
109	27	2.1%
Other values (125)	994	76.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
40	1	0.1%
44	1	0.1%
45	2	0.2%
48	4	0.3%
50	2	0.2%

Value	Count	Frequency (%)
427	1	0.1%
385	1	0.1%
371	1	0.1%
342	1	0.1%
300	1	0.1%

gros_area
Real number (ℝ_≥0)

Distinct	144
Distinct (%)	11.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	101.5138037
Minimum	44
Maximum	427
Zeros	0
Zeros (%)	0.0%
Memory size	10.2 KiB

Quantile statistics

Minimum	44
5-th percentile	64
Q1	77
median	100
Q3	112
95-th percentile	145
Maximum	427
Range	383
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	37.36028721
Coefficient of variation (CV)	0.3680315962
Kurtosis	21.70282905
Mean	101.5138037
Median Absolute Deviation (MAD)	16
Skewness	3.646046779
Sum	132374
Variance	1395.79106
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	39	3.0%
112	36	2.8%
108	32	2.5%
98	31	2.4%
104	31	2.4%
105	29	2.2%
106	29	2.2%
109	27	2.1%
103	26	2.0%
90	26	2.0%
Other values (134)	998	76.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
44	1	0.1%
45	1	0.1%
48	3	0.2%
50	1	0.1%
51	1	0.1%

Value	Count	Frequency (%)
427	1	0.1%
393	1	0.1%
391	1	0.1%
385	1	0.1%
371	1	0.1%

bedrooms
Real number (ℝ_≥0)

Distinct	6
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.769171779
Minimum	0
Maximum	5
Zeros	4
Zeros (%)	0.3%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	3
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.5964339574
Coefficient of variation (CV)	0.337126086
Kurtosis	0.783139381
Mean	1.769171779
Median Absolute Deviation (MAD)	0
Skewness	0.239167673
Sum	2307
Variance	0.3557334655
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	806	61.8%
1	397	30.4%
3	91	7.0%
4	5	0.4%
0	4	0.3%
5	1	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4	0.3%
1	397	30.4%
2	806	61.8%
3	91	7.0%
4	5	0.4%

Value	Count	Frequency (%)
5	1	0.1%
4	5	0.4%
3	91	7.0%
2	806	61.8%
1	397	30.4%

bathrooms
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.435582822
Minimum	0
Maximum	21
Zeros	15
Zeros (%)	1.2%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	2
Maximum	21
Range	21
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7569524049
Coefficient of variation (CV)	0.5272788119
Kurtosis	341.6391126
Mean	1.435582822
Median Absolute Deviation (MAD)	0
Skewness	13.33526062
Sum	1872
Variance	0.5729769433
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	731	56.1%
2	553	42.4%
0	15	1.2%
4	2	0.2%
3	2	0.2%
21	1	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	15	1.2%
1	731	56.1%
2	553	42.4%
3	2	0.2%
4	2	0.2%

Value	Count	Frequency (%)
21	1	0.1%
4	2	0.2%
3	2	0.2%
2	553	42.4%
1	731	56.1%

other_rooms
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	5
Distinct (%)	0.5%
Missing	309
Missing (%)	23.7%
Infinite	0
Infinite (%)	0.0%

Mean	0.02713567839
Minimum	0
Maximum	4
Zeros	977
Zeros (%)	74.9%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	4
Range	4
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2293094714
Coefficient of variation (CV)	8.450478669
Kurtosis	142.8931281
Mean	0.02713567839
Median Absolute Deviation (MAD)	0
Skewness	10.92900813
Sum	27
Variance	0.05258283369
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
0	977	74.9%
1	12	0.9%
2	4	0.3%
3	1	0.1%
4	1	0.1%
(Missing)	309	23.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	977	74.9%
1	12	0.9%
2	4	0.3%
3	1	0.1%
4	1	0.1%

Value	Count	Frequency (%)
4	1	0.1%
3	1	0.1%
2	4	0.3%
1	12	0.9%
0	977	74.9%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	df_index	property_status	price	interior_area	gros_area	bedrooms	bathrooms	other_rooms
0	20102	New	66000.0	110.0	110.0	2	2.0	0.0
1	19641	Used	65000.0	119.0	119.0	2	2.0	0.0
2	20146	New	39000.0	69.0	69.0	1	1.0	0.0
3	20100	New	63000.0	103.0	103.0	2	2.0	0.0
4	19650	New	41000.0	75.0	75.0	1	1.0	0.0
5	19686	New	46000.0	70.0	70.0	1	1.0	0.0
6	20105	New	52000.0	98.0	98.0	2	2.0	0.0
7	13781	Used	55000.0	61.0	61.0	1	1.0	NaN
8	11496	Not Applicable	100000.0	114.0	114.0	2	2.0	NaN
9	17142	Used	59000.0	75.0	120.0	1	1.0	0.0

Last rows

	df_index	property_status	price	interior_area	gros_area	bedrooms	bathrooms	other_rooms
1294	826	Used	49000.0	64.0	64.0	1	1.0	0.0
1295	19365	New	66960.0	112.0	112.0	2	2.0	0.0
1296	19204	Used	50000.0	89.0	89.0	1	1.0	0.0
1297	19366	New	64350.0	117.0	117.0	2	2.0	0.0
1298	17373	Used	66960.0	108.0	108.0	2	2.0	0.0
1299	11572	Not Applicable	72000.0	90.0	90.0	2	2.0	NaN
1300	17374	Used	45500.0	73.0	73.0	1	1.0	0.0
1301	18158	Used	46600.0	78.0	78.0	2	1.0	0.0
1302	19367	New	39600.0	66.0	66.0	1	1.0	0.0
1303	19368	Used	63000.0	103.0	103.0	2	1.0	0.0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows